package com.example.managesystem.mapper;

import com.example.managesystem.dto.FileDTO;
import com.example.managesystem.dto.SubmitMatrialDTO;
import com.example.managesystem.entity.Achievement;
import com.example.managesystem.entity.File;
import org.apache.ibatis.annotations.*;

import java.time.LocalDate;

@Mapper
public interface AchievementMapper {
    /**
     * 往成果表当中插入数据
     * @param achievement
     */
    @Insert("insert into achievement (achievement_id,item_id, thesis_status, thesis_name, publication_name, find_type, find_id, thesis_firstAuthor, patent_status, patent_name, auth_time, patent_id, works_status, works_name, works_firstAuthor) values (#{achievement.achievementId},#{achievement.itemId},  #{achievement.thesisStatus}, #{achievement.thesisName}, #{achievement.publicationName}, #{achievement.findType}, #{achievement.findId}, #{achievement.thesisFirstAuthor}, #{achievement.patentStatus}, #{achievement.patentName}, #{achievement.authTime}, #{achievement.patentId}, #{achievement.worksStatus}, #{achievement.worksName}, #{achievement.worksFirstAuthor})")
    void insertAchievement(@Param("achievement") Achievement achievement);

}
